[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '142' >
7 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
96 | 19 | 1987-04-20 | Finance | candy0@adventure-works.com | Candy Spoon | 920-555-0177 | 60517918 | Candy | F | 2020-03-03 | Spoon | adventure-works\candy0 | S | L | 142 | 2 | 920-555-0177 | 50 | 2020-03-03 | Current | Accounts Receivable Specialist | 61 | ||
133 | 19 | 1995-11-16 | Finance | bryan1@adventure-works.com | Bryan Walton | 935-555-0199 | 931190412 | Bryan | M | 2020-03-21 | Walton | adventure-works\bryan1 | S | A | 142 | 2 | 935-555-0199 | 51 | 2020-03-21 | Current | Accounts Receivable Specialist | 62 | ||
170 | 19 | 1988-04-11 | Finance | dragan0@adventure-works.com | Dragan Tomic | 117-555-0185 | 663843431 | Dragan | M | 2020-04-08 | Tomic | adventure-works\dragan0 | M | K | 142 | 2 | 117-555-0185 | 51 | 2020-04-08 | Current | Accounts Payable Specialist | 63 | ||
182 | 26.4423 | 1987-03-01 | Finance | barbara1@adventure-works.com | Barbara Moreland | 822-555-0145 | 363910111 | Barbara | F | 2020-04-15 | Moreland | adventure-works\barbara1 | M | C | 142 | 2 | 822-555-0145 | 1 | 49 | 2020-04-15 | Current | Accountant | 58 | |
205 | 19 | 1990-05-04 | Finance | janet0@adventure-works.com | Janet Sheperdigian | 393-555-0186 | 519756660 | Janet | F | 2020-04-26 | Sheperdigian | adventure-works\janet0 | M | L | 142 | 2 | 393-555-0186 | 52 | 2020-04-26 | Current | Accounts Payable Specialist | 64 | ||
220 | 26.4423 | 1990-08-26 | Finance | mike0@adventure-works.com | Mike Seamans | 927-555-0150 | 480951955 | Mike | M | 2020-05-03 | Seamans | adventure-works\mike0 | S | K | 142 | 2 | 927-555-0150 | 1 | 49 | 2020-05-03 | Current | Accountant | 59 | |
61 | 19 | 1987-05-02 | Finance | deborah0@adventure-works.com | Deborah Poe | 602-555-0194 | 363923697 | Deborah | F | 2020-02-13 | Poe | adventure-works\deborah0 | M | E | 142 | 2 | 602-555-0194 | 50 | 2020-02-13 | Current | Accounts Receivable Specialist | 60 |
Generated 2025-08-25 18:55:58.605 UTC